package com.qf.smsplatfrom.mapper;

import com.qf.smsplatfrom.pojo.TBlackList;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface BlackListMapper {
    @Select("select * from t_black_list where id = #{id}")
    TBlackList findBlackById(Long id);
    @Insert("insert into t_black_list(mobile,owntype,creater) values(#{mobile},#{owntype},#{creater})")
    int addBlack(TBlackList tBlackList);
    @Select("select * from t_black_list")
    List<TBlackList> showAll();

    int updateBlack(TBlackList tBlackList);
    int deleteBlackId(@Param("ids") List<Integer> ids);
    int deleteNoBlackId(@Param("ids") List<Integer> ids,@Param("creater") Long creater);
}
